OneDrive Relational Database Development
Last revised: January 3, 2016
| Instructor's Notes | |||
|
First Day Powerpoint 10-Steps for Database Design Student Database Field List Unit 1- Database Design power point  Unit 1 YouTube Videos
|
|
How to design databases (without all the technical jargon). |
|
|
Concepts of Database Design |
|
Details for each of the 10 steps of database design. |
|
|
Data Dictionary Template |
|
Word template for database data dictionary |
|
|
SQL: Creating and Populating Database Tables Unit 2 YouTube Videos
|
|
Notes on how to create new tables, delete tables, populate tables, delete records, update records, and view records using SQL. |
|
|
SQL: Single Table Queries Unit 3 YouTube Videos
|
|
Basics of SQL queries using the SELECT command. Covers the WHERE clause, ORDER BY clause, GROUP BY clause and calculated fields. |
|
|
SQL: Multi-Table Queries Unit 4 YouTube Videos
|
|
Advanced SQL queries to combine data from multiple tables. Includes discussions of Joins, subqueries, self joins, UNION, INTERSECT, MINUS. |
|
|
Updating Database Structure and Data Unit 5 YouTube Videos
|
|
SQL queries to change existing data in a database and to change the structure of existing tables. |
|
|
Views, Indexes and Security Unit 6 YouTube Videos
|
|
SQL queries to create, manage and use views and indexes. SQL commands to grant privileges to other users. |
| Labs | Guided Learning Exercises | ||
|
|
PortableApps Lab |
|
Lab to create PortableApps USB drive that will be used to create HTML, CSS and JavaScript |
|
|
PortableApps xampp 1.8.3 download |
|
zip file for lab Lab to create PortableApps USB drive that will be used to create HTML, CSS, MySQL, and JavaScript |
|
|
SQL 1 - Creating Tables |
|
Lab to experiment with creating and populating tables. |
| Assignments | |||
|
|
Due Date Policies |
|
Policies regarding assignment due dates, NQA coupons, updates and tickets |
|
|
Tickets |
|
Daily mini-assignments required to get into the next class period. |
|
|
Terminology Worksheet |
|
DBMS terminology worksheet |
|
|
ERD Practice |
|
Small assignment to practice building ERDs |
|
|
Database Design Assignment Part 1 |
|
Assignment to create ERDs and Data Dictionaries for Premiere Products. |
|
|
Database Design Assignment Part 2 |
|
Assignment to create ERDs and Data Dictionaries for Henry Books and Alexamara Marina. |
|
|
SQL Build and Populate |
|
Assignment to create databases, tables and records. |
|
|
Single Table Queries Master Files Result Set Key |
|
Assignment related to Chapter 4 in the text (Single Table Queries) MySQL Master Files for assignments. Use Workbench to import into server. Compare your query results to mine. |
|
|
Multi-Table Queries Result Set Key |
|
Assignment related to Chapter 5 in the text (Multiple-Table Queries) Compare your query results to mine. |
|
|
Updating Structure and Data |
|
Assignment related to Chapter 6 in the text (Updating Data) |
|
|
Views, Indexes and Security Result Set Key |
|
Assignment related to Chapter 7 in the text. Compare your query results to mine. |
| Evaluation Sheets | Evaluate your own assignments before turning them in. | ||
|
|
Premiere Products Database Design |
|
Evaluation sheet for Premiere Products Database Design assignment |
|
|
Henry Books and Alexamara Marina Database Design |
|
Evaluation sheet for Henry Books and Alexamara Marina Database Design assignment |
|
|
SQL Build and Populate Part 2 |
|
Evaluation sheet for Rentals SQL build and populates commands assignment. |
| Handouts | |||
|
|
Installing XAMPP and MySQL Query Browser |
|
How to install XAMPP to get a portable version of MySQL. |
|
|
Exporting and Importing MySQL Databases |
|
Instructions for how use phpMyAdmin to back up and restore your MySQL databases. Used to transfer databases from school to home and vice versa. |
| Additional Resources | |||
|
|
Database Design Resource |
|
Good database terminology resource. |
| Course Topics and Schedule | |
| Anticipated Lecture and Assignment Schedule | lecture and assignment schedule |
